﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DreametryDBDataSet" targetNamespace="http://tempuri.org/DreametryDBDataSet.xsd" xmlns:mstns="http://tempuri.org/DreametryDBDataSet.xsd" xmlns="http://tempuri.org/DreametryDBDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="DreametryDBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="DreametryDBConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.dreametryVersion2.Properties.Settings.GlobalReference.Default.DreametryDBConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="employeeTableAdapter" GeneratorDataComponentClassName="employeeTableAdapter" Name="employee" UserDataComponentName="employeeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DreametryDBConnectionString (Settings)" DbObjectName="DreametryDB.dbo.employee" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [employee] WHERE (([emp_id] = @Original_emp_id) AND ((@IsNull_fullname = 1 AND [fullname] IS NULL) OR ([fullname] = @Original_fullname)) AND ((@IsNull_folder = 1 AND [folder] IS NULL) OR ([folder] = @Original_folder)) AND ((@IsNull_username = 1 AND [username] IS NULL) OR ([username] = @Original_username)) AND ((@IsNull_pc_ip_address = 1 AND [pc_ip_address] IS NULL) OR ([pc_ip_address] = @Original_pc_ip_address)) AND ((@IsNull_color_scheme = 1 AND [color_scheme] IS NULL) OR ([color_scheme] = @Original_color_scheme)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fullname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fullname" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fullname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fullname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_folder" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="folder" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_folder" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="folder" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pc_ip_address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pc_ip_address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_pc_ip_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pc_ip_address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_color_scheme" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="color_scheme" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_color_scheme" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="color_scheme" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [employee] ([emp_id], [fullname], [folder], [username], [password], [picture], [pc_ip_address], [color_scheme]) VALUES (@emp_id, @fullname, @folder, @username, @password, @picture, @pc_ip_address, @color_scheme);
SELECT emp_id, fullname, folder, username, password, picture, pc_ip_address, color_scheme FROM employee WHERE (emp_id = @emp_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fullname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fullname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@folder" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="folder" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@picture" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="picture" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@pc_ip_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pc_ip_address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@color_scheme" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="color_scheme" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT emp_id, fullname, folder, username, password, picture, pc_ip_address, color_scheme FROM employee</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [employee] SET [emp_id] = @emp_id, [fullname] = @fullname, [folder] = @folder, [username] = @username, [password] = @password, [picture] = @picture, [pc_ip_address] = @pc_ip_address, [color_scheme] = @color_scheme WHERE (([emp_id] = @Original_emp_id) AND ((@IsNull_fullname = 1 AND [fullname] IS NULL) OR ([fullname] = @Original_fullname)) AND ((@IsNull_folder = 1 AND [folder] IS NULL) OR ([folder] = @Original_folder)) AND ((@IsNull_username = 1 AND [username] IS NULL) OR ([username] = @Original_username)) AND ((@IsNull_pc_ip_address = 1 AND [pc_ip_address] IS NULL) OR ([pc_ip_address] = @Original_pc_ip_address)) AND ((@IsNull_color_scheme = 1 AND [color_scheme] IS NULL) OR ([color_scheme] = @Original_color_scheme)));
SELECT emp_id, fullname, folder, username, password, picture, pc_ip_address, color_scheme FROM employee WHERE (emp_id = @emp_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fullname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fullname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@folder" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="folder" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@picture" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="picture" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@pc_ip_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pc_ip_address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@color_scheme" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="color_scheme" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fullname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fullname" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fullname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fullname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_folder" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="folder" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_folder" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="folder" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pc_ip_address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pc_ip_address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_pc_ip_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pc_ip_address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_color_scheme" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="color_scheme" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_color_scheme" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="color_scheme" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="emp_id" DataSetColumn="emp_id" />
              <Mapping SourceColumn="fullname" DataSetColumn="fullname" />
              <Mapping SourceColumn="folder" DataSetColumn="folder" />
              <Mapping SourceColumn="username" DataSetColumn="username" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
              <Mapping SourceColumn="picture" DataSetColumn="picture" />
              <Mapping SourceColumn="pc_ip_address" DataSetColumn="pc_ip_address" />
              <Mapping SourceColumn="color_scheme" DataSetColumn="color_scheme" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmployeeTaskTableAdapter" GeneratorDataComponentClassName="EmployeeTaskTableAdapter" Name="EmployeeTask" UserDataComponentName="EmployeeTaskTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DreametryDBConnectionString (Settings)" DbObjectName="DreametryDB.dbo.EmployeeTask" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[EmployeeTask] WHERE (([emp_task_id] = @Original_emp_task_id) AND ([task_id] = @Original_task_id) AND ([emp_id] = @Original_emp_id) AND ((@IsNull_part = 1 AND [part] IS NULL) OR ([part] = @Original_part)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_emp_task_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_task_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_task_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="task_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_part" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="part" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_part" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="part" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[EmployeeTask] ([task_id], [emp_id], [part]) VALUES (@task_id, @emp_id, @part);
SELECT emp_task_id, task_id, emp_id, part FROM EmployeeTask WHERE (emp_task_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@task_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="task_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@part" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="part" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT emp_task_id, task_id, emp_id, part FROM dbo.EmployeeTask</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[EmployeeTask] SET [task_id] = @task_id, [emp_id] = @emp_id, [part] = @part WHERE (([emp_task_id] = @Original_emp_task_id) AND ([task_id] = @Original_task_id) AND ([emp_id] = @Original_emp_id) AND ((@IsNull_part = 1 AND [part] IS NULL) OR ([part] = @Original_part)));
SELECT emp_task_id, task_id, emp_id, part FROM EmployeeTask WHERE (emp_task_id = @emp_task_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@task_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="task_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@part" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="part" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_emp_task_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_task_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_task_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="task_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_part" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="part" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_part" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="part" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="emp_task_id" ColumnName="emp_task_id" DataSourceName="DreametryDB.dbo.EmployeeTask" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@emp_task_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="emp_task_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="emp_task_id" DataSetColumn="emp_task_id" />
              <Mapping SourceColumn="task_id" DataSetColumn="task_id" />
              <Mapping SourceColumn="emp_id" DataSetColumn="emp_id" />
              <Mapping SourceColumn="part" DataSetColumn="part" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RoleTableTableAdapter" GeneratorDataComponentClassName="RoleTableTableAdapter" Name="RoleTable" UserDataComponentName="RoleTableTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DreametryDBConnectionString (Settings)" DbObjectName="DreametryDB.dbo.RoleTable" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[RoleTable] ([emp_id], [Designer], [Verifier], [Uploader], [AdminUser], [AdminChat]) VALUES (@emp_id, @Designer, @Verifier, @Uploader, @AdminUser, @AdminChat)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Designer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Designer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Verifier" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Verifier" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Uploader" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Uploader" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AdminUser" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdminUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AdminChat" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdminChat" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT emp_id, Designer, Verifier, Uploader, AdminUser, AdminChat FROM dbo.RoleTable</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="emp_id" DataSetColumn="emp_id" />
              <Mapping SourceColumn="Designer" DataSetColumn="Designer" />
              <Mapping SourceColumn="Verifier" DataSetColumn="Verifier" />
              <Mapping SourceColumn="Uploader" DataSetColumn="Uploader" />
              <Mapping SourceColumn="AdminUser" DataSetColumn="AdminUser" />
              <Mapping SourceColumn="AdminChat" DataSetColumn="AdminChat" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TaskCategoryTableAdapter" GeneratorDataComponentClassName="TaskCategoryTableAdapter" Name="TaskCategory" UserDataComponentName="TaskCategoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DreametryDBConnectionString (Settings)" DbObjectName="DreametryDB.dbo.TaskCategory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TaskCategory] WHERE (([category_id] = @Original_category_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_category_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="category_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TaskCategory] ([category]) VALUES (@category);
SELECT category_id, category FROM TaskCategory WHERE (category_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@category" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="category" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT category_id, category FROM dbo.TaskCategory</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TaskCategory] SET [category] = @category WHERE (([category_id] = @Original_category_id));
SELECT category_id, category FROM TaskCategory WHERE (category_id = @category_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@category" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="category" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_category_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="category_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="category_id" ColumnName="category_id" DataSourceName="DreametryDB.dbo.TaskCategory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@category_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="category_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="category_id" DataSetColumn="category_id" />
              <Mapping SourceColumn="category" DataSetColumn="category" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TaskTableTableAdapter" GeneratorDataComponentClassName="TaskTableTableAdapter" Name="TaskTable" UserDataComponentName="TaskTableTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DreametryDBConnectionString (Settings)" DbObjectName="DreametryDB.dbo.TaskTable" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TaskTable] WHERE (([task_id] = @Original_task_id) AND ((@IsNull_date_updated = 1 AND [date_updated] IS NULL) OR ([date_updated] = @Original_date_updated)) AND ((@IsNull_date_created = 1 AND [date_created] IS NULL) OR ([date_created] = @Original_date_created)) AND ((@IsNull_status_id = 1 AND [status_id] IS NULL) OR ([status_id] = @Original_status_id)) AND ((@IsNull_reported = 1 AND [reported] IS NULL) OR ([reported] = @Original_reported)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_task_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="task_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_updated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_updated" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_updated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_updated" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_created" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_created" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_created" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_created" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_reported" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="reported" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_reported" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reported" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TaskTable] ([task_name], [task_desciption], [reference_link], [output_description], [date_updated], [date_created], [status_id], [reported]) VALUES (@task_name, @task_desciption, @reference_link, @output_description, @date_updated, @date_created, @status_id, @reported);
SELECT task_id, task_name, task_desciption, reference_link, output_description, date_updated, date_created, status_id, reported FROM TaskTable WHERE (task_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@task_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="task_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@task_desciption" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="task_desciption" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@reference_link" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reference_link" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@output_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="output_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_updated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_updated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_created" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_created" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@reported" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reported" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT task_id, task_name, task_desciption, reference_link, output_description, date_updated, date_created, status_id, reported FROM dbo.TaskTable</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TaskTable] SET [task_name] = @task_name, [task_desciption] = @task_desciption, [reference_link] = @reference_link, [output_description] = @output_description, [date_updated] = @date_updated, [date_created] = @date_created, [status_id] = @status_id, [reported] = @reported WHERE (([task_id] = @Original_task_id) AND ((@IsNull_date_updated = 1 AND [date_updated] IS NULL) OR ([date_updated] = @Original_date_updated)) AND ((@IsNull_date_created = 1 AND [date_created] IS NULL) OR ([date_created] = @Original_date_created)) AND ((@IsNull_status_id = 1 AND [status_id] IS NULL) OR ([status_id] = @Original_status_id)) AND ((@IsNull_reported = 1 AND [reported] IS NULL) OR ([reported] = @Original_reported)));
SELECT task_id, task_name, task_desciption, reference_link, output_description, date_updated, date_created, status_id, reported FROM TaskTable WHERE (task_id = @task_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@task_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="task_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@task_desciption" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="task_desciption" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@reference_link" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reference_link" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@output_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="output_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_updated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_updated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_created" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_created" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@reported" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reported" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_task_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="task_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_updated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_updated" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_updated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_updated" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_created" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_created" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_created" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_created" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_reported" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="reported" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_reported" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reported" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="task_id" ColumnName="task_id" DataSourceName="DreametryDB.dbo.TaskTable" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@task_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="task_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="task_id" DataSetColumn="task_id" />
              <Mapping SourceColumn="task_name" DataSetColumn="task_name" />
              <Mapping SourceColumn="task_desciption" DataSetColumn="task_desciption" />
              <Mapping SourceColumn="reference_link" DataSetColumn="reference_link" />
              <Mapping SourceColumn="output_description" DataSetColumn="output_description" />
              <Mapping SourceColumn="date_updated" DataSetColumn="date_updated" />
              <Mapping SourceColumn="date_created" DataSetColumn="date_created" />
              <Mapping SourceColumn="status_id" DataSetColumn="status_id" />
              <Mapping SourceColumn="reported" DataSetColumn="reported" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WorkFlowTableAdapter" GeneratorDataComponentClassName="WorkFlowTableAdapter" Name="WorkFlow" UserDataComponentName="WorkFlowTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DreametryDBConnectionString (Settings)" DbObjectName="DreametryDB.dbo.WorkFlow" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[WorkFlow] WHERE (([status_id] = @Original_status_id) AND ((@IsNull_taskCategory = 1 AND [taskCategory] IS NULL) OR ([taskCategory] = @Original_taskCategory)) AND ((@IsNull_taskLevel = 1 AND [taskLevel] IS NULL) OR ([taskLevel] = @Original_taskLevel)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taskCategory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taskCategory" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_taskCategory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taskCategory" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taskLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taskLevel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_taskLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taskLevel" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[WorkFlow] ([status_id], [flow_name], [taskCategory], [taskLevel], [forUser]) VALUES (@status_id, @flow_name, @taskCategory, @taskLevel, @forUser);
SELECT status_id, flow_name, taskCategory, taskLevel, forUser FROM WorkFlow WHERE (status_id = @status_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@flow_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="flow_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@taskCategory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taskCategory" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@taskLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taskLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@forUser" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="forUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT status_id, flow_name, taskCategory, taskLevel, forUser FROM dbo.WorkFlow</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[WorkFlow] SET [status_id] = @status_id, [flow_name] = @flow_name, [taskCategory] = @taskCategory, [taskLevel] = @taskLevel, [forUser] = @forUser WHERE (([status_id] = @Original_status_id) AND ((@IsNull_taskCategory = 1 AND [taskCategory] IS NULL) OR ([taskCategory] = @Original_taskCategory)) AND ((@IsNull_taskLevel = 1 AND [taskLevel] IS NULL) OR ([taskLevel] = @Original_taskLevel)));
SELECT status_id, flow_name, taskCategory, taskLevel, forUser FROM WorkFlow WHERE (status_id = @status_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@flow_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="flow_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@taskCategory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taskCategory" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@taskLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taskLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@forUser" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="forUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taskCategory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taskCategory" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_taskCategory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taskCategory" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taskLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taskLevel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_taskLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taskLevel" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="status_id" DataSetColumn="status_id" />
              <Mapping SourceColumn="flow_name" DataSetColumn="flow_name" />
              <Mapping SourceColumn="taskCategory" DataSetColumn="taskCategory" />
              <Mapping SourceColumn="taskLevel" DataSetColumn="taskLevel" />
              <Mapping SourceColumn="forUser" DataSetColumn="forUser" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ViewEmployeeRoleTableAdapter" GeneratorDataComponentClassName="ViewEmployeeRoleTableAdapter" Name="ViewEmployeeRole" UserDataComponentName="ViewEmployeeRoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DreametryDBConnectionString (Settings)" DbObjectName="DreametryDB.dbo.ViewEmployeeRole" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT AdminUser, Designer, Uploader, Verifier FROM dbo.ViewEmployeeRole</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AdminUser" DataSetColumn="AdminUser" />
              <Mapping SourceColumn="Designer" DataSetColumn="Designer" />
              <Mapping SourceColumn="Uploader" DataSetColumn="Uploader" />
              <Mapping SourceColumn="Verifier" DataSetColumn="Verifier" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ViewEmployeeTaskDataTableAdapter" GeneratorDataComponentClassName="ViewEmployeeTaskDataTableAdapter" Name="ViewEmployeeTaskData" UserDataComponentName="ViewEmployeeTaskDataTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DreametryDBConnectionString (Settings)" DbObjectName="DreametryDB.dbo.ViewEmployeeTaskData" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT task_id, fullname, emp_id, task_name, task_desciption, output_description, date_created, date_updated, flow_name, taskLevel, category, category_id, part, reported, forUser, reference_link FROM ViewEmployeeTaskData</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="task_id" DataSetColumn="task_id" />
              <Mapping SourceColumn="fullname" DataSetColumn="fullname" />
              <Mapping SourceColumn="emp_id" DataSetColumn="emp_id" />
              <Mapping SourceColumn="task_name" DataSetColumn="task_name" />
              <Mapping SourceColumn="task_desciption" DataSetColumn="task_desciption" />
              <Mapping SourceColumn="output_description" DataSetColumn="output_description" />
              <Mapping SourceColumn="date_created" DataSetColumn="date_created" />
              <Mapping SourceColumn="date_updated" DataSetColumn="date_updated" />
              <Mapping SourceColumn="flow_name" DataSetColumn="flow_name" />
              <Mapping SourceColumn="taskLevel" DataSetColumn="taskLevel" />
              <Mapping SourceColumn="category" DataSetColumn="category" />
              <Mapping SourceColumn="category_id" DataSetColumn="category_id" />
              <Mapping SourceColumn="part" DataSetColumn="part" />
              <Mapping SourceColumn="reported" DataSetColumn="reported" />
              <Mapping SourceColumn="forUser" DataSetColumn="forUser" />
              <Mapping SourceColumn="reference_link" DataSetColumn="reference_link" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProcedureTableAdapter" GeneratorDataComponentClassName="ProcedureTableAdapter" Name="Procedure" UserDataComponentName="ProcedureTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DreametryDBConnectionString (Settings)" DbObjectName="DreametryDB.dbo.[Procedure]" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[Procedure]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@taskname" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="task_id" DataSetColumn="task_id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CommentsTableTableAdapter" GeneratorDataComponentClassName="CommentsTableTableAdapter" Name="CommentsTable" UserDataComponentName="CommentsTableTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DreametryDBConnectionString (Settings)" DbObjectName="DreametryDB.dbo.CommentsTable" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CommentsTable] ([emp_id], [task_id], [comment], [comment_date]) VALUES (@emp_id, @task_id, @comment, @comment_date)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@task_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="task_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@comment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@comment_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="comment_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT emp_id, task_id, comment, comment_date FROM dbo.CommentsTable</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="emp_id" DataSetColumn="emp_id" />
              <Mapping SourceColumn="task_id" DataSetColumn="task_id" />
              <Mapping SourceColumn="comment" DataSetColumn="comment" />
              <Mapping SourceColumn="comment_date" DataSetColumn="comment_date" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="DreametryDBConnectionString (Settings)" DbObjectName="DreametryDB.dbo.AddLevel" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="AddLevel" MethodsParameterType="CLR" Modifier="Public" Name="AddLevel" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="AddLevel">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.AddLevel</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@taskId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="DreametryDBConnectionString (Settings)" DbObjectName="DreametryDB.dbo.CollaborateTask" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="CollaborateTask" MethodsParameterType="CLR" Modifier="Public" Name="CollaborateTask" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="CollaborateTask">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.CollaborateTask</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@taskid" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@empid" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="DreametryDBConnectionString (Settings)" DbObjectName="DreametryDB.dbo.CreateTask" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="CreateTask" MethodsParameterType="CLR" Modifier="Public" Name="CreateTask" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="CreateTask">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.CreateTask</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@taskname" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@taskdescription" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@refrenceLink" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idEmp" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@taskCategory" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@getdata" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@getTaskid" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="DreametryDBConnectionString (Settings)" DbObjectName="DreametryDB.dbo.DecLevel" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="DecLevel" MethodsParameterType="CLR" Modifier="Public" Name="DecLevel" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="DecLevel">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.DecLevel</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@taskId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="DreametryDBConnectionString (Settings)" DbObjectName="DreametryDB.dbo.ReportedYes" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="ReportedYes" MethodsParameterType="CLR" Modifier="Public" Name="ReportedYes" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="ReportedYes">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.ReportedYes</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DreametryDBDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="DreametryDBDataSet" msprop:Generator_UserDSName="DreametryDBDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="employee" msprop:Generator_TableClassName="employeeDataTable" msprop:Generator_TableVarName="tableemployee" msprop:Generator_RowChangedName="employeeRowChanged" msprop:Generator_TablePropName="employee" msprop:Generator_RowDeletingName="employeeRowDeleting" msprop:Generator_RowChangingName="employeeRowChanging" msprop:Generator_RowEvHandlerName="employeeRowChangeEventHandler" msprop:Generator_RowDeletedName="employeeRowDeleted" msprop:Generator_RowClassName="employeeRow" msprop:Generator_UserTableName="employee" msprop:Generator_RowEvArgName="employeeRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="emp_id" msprop:Generator_ColumnVarNameInTable="columnemp_id" msprop:Generator_ColumnPropNameInRow="emp_id" msprop:Generator_ColumnPropNameInTable="emp_idColumn" msprop:Generator_UserColumnName="emp_id" type="xs:int" />
              <xs:element name="fullname" msprop:Generator_ColumnVarNameInTable="columnfullname" msprop:Generator_ColumnPropNameInRow="fullname" msprop:Generator_ColumnPropNameInTable="fullnameColumn" msprop:Generator_UserColumnName="fullname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="folder" msprop:Generator_ColumnVarNameInTable="columnfolder" msprop:Generator_ColumnPropNameInRow="folder" msprop:Generator_ColumnPropNameInTable="folderColumn" msprop:Generator_UserColumnName="folder" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="username" msprop:Generator_ColumnVarNameInTable="columnusername" msprop:Generator_ColumnPropNameInRow="username" msprop:Generator_ColumnPropNameInTable="usernameColumn" msprop:Generator_UserColumnName="username" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="picture" msprop:Generator_ColumnVarNameInTable="columnpicture" msprop:Generator_ColumnPropNameInRow="picture" msprop:Generator_ColumnPropNameInTable="pictureColumn" msprop:Generator_UserColumnName="picture" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="pc_ip_address" msprop:Generator_ColumnVarNameInTable="columnpc_ip_address" msprop:Generator_ColumnPropNameInRow="pc_ip_address" msprop:Generator_ColumnPropNameInTable="pc_ip_addressColumn" msprop:Generator_UserColumnName="pc_ip_address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="color_scheme" msprop:Generator_ColumnVarNameInTable="columncolor_scheme" msprop:Generator_ColumnPropNameInRow="color_scheme" msprop:Generator_ColumnPropNameInTable="color_schemeColumn" msprop:Generator_UserColumnName="color_scheme" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EmployeeTask" msprop:Generator_TableClassName="EmployeeTaskDataTable" msprop:Generator_TableVarName="tableEmployeeTask" msprop:Generator_RowChangedName="EmployeeTaskRowChanged" msprop:Generator_TablePropName="EmployeeTask" msprop:Generator_RowDeletingName="EmployeeTaskRowDeleting" msprop:Generator_RowChangingName="EmployeeTaskRowChanging" msprop:Generator_RowEvHandlerName="EmployeeTaskRowChangeEventHandler" msprop:Generator_RowDeletedName="EmployeeTaskRowDeleted" msprop:Generator_RowClassName="EmployeeTaskRow" msprop:Generator_UserTableName="EmployeeTask" msprop:Generator_RowEvArgName="EmployeeTaskRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="emp_task_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnemp_task_id" msprop:Generator_ColumnPropNameInRow="emp_task_id" msprop:Generator_ColumnPropNameInTable="emp_task_idColumn" msprop:Generator_UserColumnName="emp_task_id" type="xs:int" />
              <xs:element name="task_id" msprop:Generator_ColumnVarNameInTable="columntask_id" msprop:Generator_ColumnPropNameInRow="task_id" msprop:Generator_ColumnPropNameInTable="task_idColumn" msprop:Generator_UserColumnName="task_id" type="xs:int" />
              <xs:element name="emp_id" msprop:Generator_ColumnVarNameInTable="columnemp_id" msprop:Generator_ColumnPropNameInRow="emp_id" msprop:Generator_ColumnPropNameInTable="emp_idColumn" msprop:Generator_UserColumnName="emp_id" type="xs:int" />
              <xs:element name="part" msprop:Generator_ColumnVarNameInTable="columnpart" msprop:Generator_ColumnPropNameInRow="part" msprop:Generator_ColumnPropNameInTable="partColumn" msprop:Generator_UserColumnName="part" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="RoleTable" msprop:Generator_TableClassName="RoleTableDataTable" msprop:Generator_TableVarName="tableRoleTable" msprop:Generator_RowChangedName="RoleTableRowChanged" msprop:Generator_TablePropName="RoleTable" msprop:Generator_RowDeletingName="RoleTableRowDeleting" msprop:Generator_RowChangingName="RoleTableRowChanging" msprop:Generator_RowEvHandlerName="RoleTableRowChangeEventHandler" msprop:Generator_RowDeletedName="RoleTableRowDeleted" msprop:Generator_RowClassName="RoleTableRow" msprop:Generator_UserTableName="RoleTable" msprop:Generator_RowEvArgName="RoleTableRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="emp_id" msprop:Generator_ColumnVarNameInTable="columnemp_id" msprop:Generator_ColumnPropNameInRow="emp_id" msprop:Generator_ColumnPropNameInTable="emp_idColumn" msprop:Generator_UserColumnName="emp_id" type="xs:int" />
              <xs:element name="Designer" msprop:Generator_ColumnVarNameInTable="columnDesigner" msprop:Generator_ColumnPropNameInRow="Designer" msprop:Generator_ColumnPropNameInTable="DesignerColumn" msprop:Generator_UserColumnName="Designer" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Verifier" msprop:Generator_ColumnVarNameInTable="columnVerifier" msprop:Generator_ColumnPropNameInRow="Verifier" msprop:Generator_ColumnPropNameInTable="VerifierColumn" msprop:Generator_UserColumnName="Verifier" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Uploader" msprop:Generator_ColumnVarNameInTable="columnUploader" msprop:Generator_ColumnPropNameInRow="Uploader" msprop:Generator_ColumnPropNameInTable="UploaderColumn" msprop:Generator_UserColumnName="Uploader" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AdminUser" msprop:Generator_ColumnVarNameInTable="columnAdminUser" msprop:Generator_ColumnPropNameInRow="AdminUser" msprop:Generator_ColumnPropNameInTable="AdminUserColumn" msprop:Generator_UserColumnName="AdminUser" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AdminChat" msprop:Generator_ColumnVarNameInTable="columnAdminChat" msprop:Generator_ColumnPropNameInRow="AdminChat" msprop:Generator_ColumnPropNameInTable="AdminChatColumn" msprop:Generator_UserColumnName="AdminChat" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TaskCategory" msprop:Generator_TableClassName="TaskCategoryDataTable" msprop:Generator_TableVarName="tableTaskCategory" msprop:Generator_RowChangedName="TaskCategoryRowChanged" msprop:Generator_TablePropName="TaskCategory" msprop:Generator_RowDeletingName="TaskCategoryRowDeleting" msprop:Generator_RowChangingName="TaskCategoryRowChanging" msprop:Generator_RowEvHandlerName="TaskCategoryRowChangeEventHandler" msprop:Generator_RowDeletedName="TaskCategoryRowDeleted" msprop:Generator_RowClassName="TaskCategoryRow" msprop:Generator_UserTableName="TaskCategory" msprop:Generator_RowEvArgName="TaskCategoryRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="category_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncategory_id" msprop:Generator_ColumnPropNameInRow="category_id" msprop:Generator_ColumnPropNameInTable="category_idColumn" msprop:Generator_UserColumnName="category_id" type="xs:int" />
              <xs:element name="category" msprop:Generator_ColumnVarNameInTable="columncategory" msprop:Generator_ColumnPropNameInRow="category" msprop:Generator_ColumnPropNameInTable="categoryColumn" msprop:Generator_UserColumnName="category" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TaskTable" msprop:Generator_TableClassName="TaskTableDataTable" msprop:Generator_TableVarName="tableTaskTable" msprop:Generator_RowChangedName="TaskTableRowChanged" msprop:Generator_TablePropName="TaskTable" msprop:Generator_RowDeletingName="TaskTableRowDeleting" msprop:Generator_RowChangingName="TaskTableRowChanging" msprop:Generator_RowEvHandlerName="TaskTableRowChangeEventHandler" msprop:Generator_RowDeletedName="TaskTableRowDeleted" msprop:Generator_RowClassName="TaskTableRow" msprop:Generator_UserTableName="TaskTable" msprop:Generator_RowEvArgName="TaskTableRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="task_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columntask_id" msprop:Generator_ColumnPropNameInRow="task_id" msprop:Generator_ColumnPropNameInTable="task_idColumn" msprop:Generator_UserColumnName="task_id" type="xs:int" />
              <xs:element name="task_name" msprop:Generator_ColumnVarNameInTable="columntask_name" msprop:Generator_ColumnPropNameInRow="task_name" msprop:Generator_ColumnPropNameInTable="task_nameColumn" msprop:Generator_UserColumnName="task_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="task_desciption" msprop:Generator_ColumnVarNameInTable="columntask_desciption" msprop:Generator_ColumnPropNameInRow="task_desciption" msprop:Generator_ColumnPropNameInTable="task_desciptionColumn" msprop:Generator_UserColumnName="task_desciption" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="reference_link" msprop:Generator_ColumnVarNameInTable="columnreference_link" msprop:Generator_ColumnPropNameInRow="reference_link" msprop:Generator_ColumnPropNameInTable="reference_linkColumn" msprop:Generator_UserColumnName="reference_link" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="output_description" msprop:Generator_ColumnVarNameInTable="columnoutput_description" msprop:Generator_ColumnPropNameInRow="output_description" msprop:Generator_ColumnPropNameInTable="output_descriptionColumn" msprop:Generator_UserColumnName="output_description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_updated" msprop:Generator_ColumnVarNameInTable="columndate_updated" msprop:Generator_ColumnPropNameInRow="date_updated" msprop:Generator_ColumnPropNameInTable="date_updatedColumn" msprop:Generator_UserColumnName="date_updated" type="xs:dateTime" minOccurs="0" />
              <xs:element name="date_created" msprop:Generator_ColumnVarNameInTable="columndate_created" msprop:Generator_ColumnPropNameInRow="date_created" msprop:Generator_ColumnPropNameInTable="date_createdColumn" msprop:Generator_UserColumnName="date_created" type="xs:dateTime" minOccurs="0" />
              <xs:element name="status_id" msprop:Generator_ColumnVarNameInTable="columnstatus_id" msprop:Generator_ColumnPropNameInRow="status_id" msprop:Generator_ColumnPropNameInTable="status_idColumn" msprop:Generator_UserColumnName="status_id" type="xs:int" minOccurs="0" />
              <xs:element name="reported" msprop:Generator_ColumnVarNameInTable="columnreported" msprop:Generator_ColumnPropNameInRow="reported" msprop:Generator_ColumnPropNameInTable="reportedColumn" msprop:Generator_UserColumnName="reported" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="WorkFlow" msprop:Generator_TableClassName="WorkFlowDataTable" msprop:Generator_TableVarName="tableWorkFlow" msprop:Generator_RowChangedName="WorkFlowRowChanged" msprop:Generator_TablePropName="WorkFlow" msprop:Generator_RowDeletingName="WorkFlowRowDeleting" msprop:Generator_RowChangingName="WorkFlowRowChanging" msprop:Generator_RowEvHandlerName="WorkFlowRowChangeEventHandler" msprop:Generator_RowDeletedName="WorkFlowRowDeleted" msprop:Generator_RowClassName="WorkFlowRow" msprop:Generator_UserTableName="WorkFlow" msprop:Generator_RowEvArgName="WorkFlowRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="status_id" msprop:Generator_ColumnVarNameInTable="columnstatus_id" msprop:Generator_ColumnPropNameInRow="status_id" msprop:Generator_ColumnPropNameInTable="status_idColumn" msprop:Generator_UserColumnName="status_id" type="xs:int" />
              <xs:element name="flow_name" msprop:Generator_ColumnVarNameInTable="columnflow_name" msprop:Generator_ColumnPropNameInRow="flow_name" msprop:Generator_ColumnPropNameInTable="flow_nameColumn" msprop:Generator_UserColumnName="flow_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="taskCategory" msprop:Generator_ColumnVarNameInTable="columntaskCategory" msprop:Generator_ColumnPropNameInRow="taskCategory" msprop:Generator_ColumnPropNameInTable="taskCategoryColumn" msprop:Generator_UserColumnName="taskCategory" type="xs:int" minOccurs="0" />
              <xs:element name="taskLevel" msprop:Generator_ColumnVarNameInTable="columntaskLevel" msprop:Generator_ColumnPropNameInRow="taskLevel" msprop:Generator_ColumnPropNameInTable="taskLevelColumn" msprop:Generator_UserColumnName="taskLevel" type="xs:int" minOccurs="0" />
              <xs:element name="forUser" msprop:Generator_ColumnVarNameInTable="columnforUser" msprop:Generator_ColumnPropNameInRow="forUser" msprop:Generator_ColumnPropNameInTable="forUserColumn" msprop:Generator_UserColumnName="forUser" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ViewEmployeeRole" msprop:Generator_TableClassName="ViewEmployeeRoleDataTable" msprop:Generator_TableVarName="tableViewEmployeeRole" msprop:Generator_RowChangedName="ViewEmployeeRoleRowChanged" msprop:Generator_TablePropName="ViewEmployeeRole" msprop:Generator_RowDeletingName="ViewEmployeeRoleRowDeleting" msprop:Generator_RowChangingName="ViewEmployeeRoleRowChanging" msprop:Generator_RowEvHandlerName="ViewEmployeeRoleRowChangeEventHandler" msprop:Generator_RowDeletedName="ViewEmployeeRoleRowDeleted" msprop:Generator_RowClassName="ViewEmployeeRoleRow" msprop:Generator_UserTableName="ViewEmployeeRole" msprop:Generator_RowEvArgName="ViewEmployeeRoleRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AdminUser" msprop:Generator_ColumnVarNameInTable="columnAdminUser" msprop:Generator_ColumnPropNameInRow="AdminUser" msprop:Generator_ColumnPropNameInTable="AdminUserColumn" msprop:Generator_UserColumnName="AdminUser" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Designer" msprop:Generator_ColumnVarNameInTable="columnDesigner" msprop:Generator_ColumnPropNameInRow="Designer" msprop:Generator_ColumnPropNameInTable="DesignerColumn" msprop:Generator_UserColumnName="Designer" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Uploader" msprop:Generator_ColumnVarNameInTable="columnUploader" msprop:Generator_ColumnPropNameInRow="Uploader" msprop:Generator_ColumnPropNameInTable="UploaderColumn" msprop:Generator_UserColumnName="Uploader" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Verifier" msprop:Generator_ColumnVarNameInTable="columnVerifier" msprop:Generator_ColumnPropNameInRow="Verifier" msprop:Generator_ColumnPropNameInTable="VerifierColumn" msprop:Generator_UserColumnName="Verifier" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ViewEmployeeTaskData" msprop:Generator_TableClassName="ViewEmployeeTaskDataDataTable" msprop:Generator_TableVarName="tableViewEmployeeTaskData" msprop:Generator_RowChangedName="ViewEmployeeTaskDataRowChanged" msprop:Generator_TablePropName="ViewEmployeeTaskData" msprop:Generator_RowDeletingName="ViewEmployeeTaskDataRowDeleting" msprop:Generator_RowChangingName="ViewEmployeeTaskDataRowChanging" msprop:Generator_RowEvHandlerName="ViewEmployeeTaskDataRowChangeEventHandler" msprop:Generator_RowDeletedName="ViewEmployeeTaskDataRowDeleted" msprop:Generator_RowClassName="ViewEmployeeTaskDataRow" msprop:Generator_UserTableName="ViewEmployeeTaskData" msprop:Generator_RowEvArgName="ViewEmployeeTaskDataRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="task_id" msprop:Generator_ColumnVarNameInTable="columntask_id" msprop:Generator_ColumnPropNameInRow="task_id" msprop:Generator_ColumnPropNameInTable="task_idColumn" msprop:Generator_UserColumnName="task_id" type="xs:int" />
              <xs:element name="fullname" msprop:Generator_ColumnVarNameInTable="columnfullname" msprop:Generator_ColumnPropNameInRow="fullname" msprop:Generator_ColumnPropNameInTable="fullnameColumn" msprop:Generator_UserColumnName="fullname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="emp_id" msprop:Generator_ColumnVarNameInTable="columnemp_id" msprop:Generator_ColumnPropNameInRow="emp_id" msprop:Generator_ColumnPropNameInTable="emp_idColumn" msprop:Generator_UserColumnName="emp_id" type="xs:int" />
              <xs:element name="task_name" msprop:Generator_ColumnVarNameInTable="columntask_name" msprop:Generator_ColumnPropNameInRow="task_name" msprop:Generator_ColumnPropNameInTable="task_nameColumn" msprop:Generator_UserColumnName="task_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="task_desciption" msprop:Generator_ColumnVarNameInTable="columntask_desciption" msprop:Generator_ColumnPropNameInRow="task_desciption" msprop:Generator_ColumnPropNameInTable="task_desciptionColumn" msprop:Generator_UserColumnName="task_desciption" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="output_description" msprop:Generator_ColumnVarNameInTable="columnoutput_description" msprop:Generator_ColumnPropNameInRow="output_description" msprop:Generator_ColumnPropNameInTable="output_descriptionColumn" msprop:Generator_UserColumnName="output_description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_created" msprop:Generator_ColumnVarNameInTable="columndate_created" msprop:Generator_ColumnPropNameInRow="date_created" msprop:Generator_ColumnPropNameInTable="date_createdColumn" msprop:Generator_UserColumnName="date_created" type="xs:dateTime" minOccurs="0" />
              <xs:element name="date_updated" msprop:Generator_ColumnVarNameInTable="columndate_updated" msprop:Generator_ColumnPropNameInRow="date_updated" msprop:Generator_ColumnPropNameInTable="date_updatedColumn" msprop:Generator_UserColumnName="date_updated" type="xs:dateTime" minOccurs="0" />
              <xs:element name="flow_name" msprop:Generator_ColumnVarNameInTable="columnflow_name" msprop:Generator_ColumnPropNameInRow="flow_name" msprop:Generator_ColumnPropNameInTable="flow_nameColumn" msprop:Generator_UserColumnName="flow_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="taskLevel" msprop:Generator_ColumnVarNameInTable="columntaskLevel" msprop:Generator_ColumnPropNameInRow="taskLevel" msprop:Generator_ColumnPropNameInTable="taskLevelColumn" msprop:Generator_UserColumnName="taskLevel" type="xs:int" minOccurs="0" />
              <xs:element name="category" msprop:Generator_ColumnVarNameInTable="columncategory" msprop:Generator_ColumnPropNameInRow="category" msprop:Generator_ColumnPropNameInTable="categoryColumn" msprop:Generator_UserColumnName="category" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="category_id" msprop:Generator_ColumnVarNameInTable="columncategory_id" msprop:Generator_ColumnPropNameInRow="category_id" msprop:Generator_ColumnPropNameInTable="category_idColumn" msprop:Generator_UserColumnName="category_id" type="xs:int" />
              <xs:element name="part" msprop:Generator_ColumnVarNameInTable="columnpart" msprop:Generator_ColumnPropNameInRow="part" msprop:Generator_ColumnPropNameInTable="partColumn" msprop:Generator_UserColumnName="part" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="reported" msprop:Generator_ColumnVarNameInTable="columnreported" msprop:Generator_ColumnPropNameInRow="reported" msprop:Generator_ColumnPropNameInTable="reportedColumn" msprop:Generator_UserColumnName="reported" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="forUser" msprop:Generator_ColumnVarNameInTable="columnforUser" msprop:Generator_ColumnPropNameInRow="forUser" msprop:Generator_ColumnPropNameInTable="forUserColumn" msprop:Generator_UserColumnName="forUser" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="reference_link" msprop:Generator_ColumnVarNameInTable="columnreference_link" msprop:Generator_ColumnPropNameInRow="reference_link" msprop:Generator_ColumnPropNameInTable="reference_linkColumn" msprop:Generator_UserColumnName="reference_link" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Procedure" msprop:Generator_TableClassName="ProcedureDataTable" msprop:Generator_TableVarName="tableProcedure" msprop:Generator_RowChangedName="ProcedureRowChanged" msprop:Generator_TablePropName="Procedure" msprop:Generator_RowDeletingName="ProcedureRowDeleting" msprop:Generator_RowChangingName="ProcedureRowChanging" msprop:Generator_RowEvHandlerName="ProcedureRowChangeEventHandler" msprop:Generator_RowDeletedName="ProcedureRowDeleted" msprop:Generator_RowClassName="ProcedureRow" msprop:Generator_UserTableName="Procedure" msprop:Generator_RowEvArgName="ProcedureRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="task_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columntask_id" msprop:Generator_ColumnPropNameInRow="task_id" msprop:Generator_ColumnPropNameInTable="task_idColumn" msprop:Generator_UserColumnName="task_id" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CommentsTable" msprop:Generator_TableClassName="CommentsTableDataTable" msprop:Generator_TableVarName="tableCommentsTable" msprop:Generator_TablePropName="CommentsTable" msprop:Generator_RowDeletingName="CommentsTableRowDeleting" msprop:Generator_RowChangingName="CommentsTableRowChanging" msprop:Generator_RowEvHandlerName="CommentsTableRowChangeEventHandler" msprop:Generator_RowDeletedName="CommentsTableRowDeleted" msprop:Generator_UserTableName="CommentsTable" msprop:Generator_RowChangedName="CommentsTableRowChanged" msprop:Generator_RowEvArgName="CommentsTableRowChangeEvent" msprop:Generator_RowClassName="CommentsTableRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="emp_id" msprop:Generator_ColumnVarNameInTable="columnemp_id" msprop:Generator_ColumnPropNameInRow="emp_id" msprop:Generator_ColumnPropNameInTable="emp_idColumn" msprop:Generator_UserColumnName="emp_id" type="xs:int" />
              <xs:element name="task_id" msprop:Generator_ColumnVarNameInTable="columntask_id" msprop:Generator_ColumnPropNameInRow="task_id" msprop:Generator_ColumnPropNameInTable="task_idColumn" msprop:Generator_UserColumnName="task_id" type="xs:int" />
              <xs:element name="comment" msprop:Generator_ColumnVarNameInTable="columncomment" msprop:Generator_ColumnPropNameInRow="comment" msprop:Generator_ColumnPropNameInTable="commentColumn" msprop:Generator_UserColumnName="comment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="comment_date" msprop:Generator_ColumnVarNameInTable="columncomment_date" msprop:Generator_ColumnPropNameInRow="comment_date" msprop:Generator_ColumnPropNameInTable="comment_dateColumn" msprop:Generator_UserColumnName="comment_date" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:employee" />
      <xs:field xpath="mstns:emp_id" />
    </xs:unique>
    <xs:unique name="EmployeeTask_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EmployeeTask" />
      <xs:field xpath="mstns:emp_task_id" />
    </xs:unique>
    <xs:unique name="TaskCategory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TaskCategory" />
      <xs:field xpath="mstns:category_id" />
    </xs:unique>
    <xs:unique name="TaskTable_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TaskTable" />
      <xs:field xpath="mstns:task_id" />
    </xs:unique>
    <xs:unique name="WorkFlow_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:WorkFlow" />
      <xs:field xpath="mstns:status_id" />
    </xs:unique>
    <xs:unique name="Procedure_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Procedure" />
      <xs:field xpath="mstns:task_id" />
    </xs:unique>
  </xs:element>
</xs:schema>